package util;

import java.sql.Connection;
import java.sql.DriverManager;

public class DBConnection {
    private String FileName;
    private int DBType;
    private Connection conn;
    private String MySqlDriver;
    private String MySqlURL;
    public DBConnection()
    {
        conn = null;
    }
    //根据数据库类型创建数据库连接，此处默认类型为1：mysql
    public Connection getConn() {

        DBType = 1;

        switch (DBType) {
            case 1:
                return (getConnToMySql());
            default:
                return null;
        }
    }
    //创建数据库连接
    public Connection getConnToMySql()
    {
        try{
            MySqlDriver = "com.mysql.cj.jdbc.Driver";
            MySqlDriver = "jdbc:mysql://localhost:3306/sky_gjh?" + "user=root&password=mysql123456" + "useUnicode=true&characterEncoding=UTF-8";
            Class.forName(MySqlDriver).newInstance();
            conn = DriverManager.getConnection(MySqlURL);
        } catch (Exception e){
        }
        return conn;
    }
}
